Spread .NET 表格控件 - 460 多种公式支持
自定义公式：支持通过内置函数和运算符来自定义公式。
灵活的引用方式：公式计算引擎支持单元格的引用、表单的交叉引用、循环引用、函数嵌套等。
灵活的引用方式：公式计算引擎支持单元格的引用、表单的交叉引用、循环引用、函数嵌套等。
数据库函数
| DAVERAGE | DCOUNT | DCOUNTA | DGET |
| DMAX | DMIN | DPRODUCT | DSTDEV |
| DSTDEVP | DSUM | DVAR | DVARP |
日期和时间函数
| DATE | DATEDIF | DATEVALUE | DAY |
| DAYS | DAYS360 | EDATE | EOMONTH |
| HOUR | ISO.CEILING | MINUTE | MONTH |
| NETWORKDAYS | NETWORKDAYS.INTL | NOW | SECOND |
| TIME | TIMEVALUE | TODAY | WEEKDAY |
| WEEKNUM | WORKDAY | WORKDAY.INTL | YEAR |
| YEARFRAC |
工程计算函数
| BESSELI | BESSELJ | BESSELK | BESSELY |
| BIN2DEC | BIN2HEX | BIN2OCT | BITAND |
| BITLSHIFT | BITOR | BITRSHIFT | BITXOR |
| COMPLEX | CONVERT | DEC2BIN | DEC2HEX |
| DEC2OCT | DELTA | ERF | ERFC |
| ERFC.PRECISE | ERF.PRECISE | GESTEP | HEX2BIN |
| HEX2DEC | HEX2OCT | IMABS | IMAGINARY |
| IMARGUMENT | IMCONJUGATE | IMCOS | IMCOSH |
| IMCOT | IMCSC | IMCSCH | IMDIV |
| IMEXP | IMLN | IMLOG10 | IMLOG2 |
| IMPOWER | IMPRODUCT | IMREAL | IMSEC |
| IMSECH | IMSIN | IMSINH | IMSQRT |
| IMSUB | IMSUM | IMTAN | OCT2BIN |
| OCT2DEC | OCT2HEX |
财务和金融函数
| ACCRINT | ACCRINTM | AMORDEGRC | AMORLINC |
| COUPDAYS | COUPDAYBS | COUPDAYSNC | COUPNCD |
| COUPNUM | COUPPCD | CUMIPMT | CUMPRINC |
| DB | DDB | DISC | DOLLAR |
| DOLLARDE | DOLLARFR | DURATION | EFFECT |
| EURO | EUROCONVERT | FV | FVSCHEDULE |
| INTRATE | IPMT | IRR | ISPMT |
| MDURATION | MIRR | NOMINAL | NPER |
| NPV | ODDFPRICE | ODDFYIELD | ODDLPRICE |
| ODDLYIELD | PDURATION | PMT | PPMT |
| PRICE | PRICEDISC | PRICEMAT | PV |
| RATE | RECEIVED | RRI | SLN |
| SYD | TBILLEQ | TBILLPRICE | TBILLYIELD |
| VDB | XIRR | XNPV | YIELD |
| YIELDDISC | YIELDMAT |
信息函数
| CELL | COUNTBLANK | ERRORTYPE | ERROR.TYPE |
| INFO | ISBLANK | ISERR | ISERROR |
| ISEVEN | ISFORMULA | ISLOGICAL | ISNA |
| ISNONTEXT | ISNUMBER | ISODD | ISREF |
| ISTEXT | N | NA | SHEET |
| SHEETS | TYPE |
逻辑函数
| AND | FALSE | IF | IFERROR |
| IFNA | IFS | NOT | OR |
| SWITCH | TRUE | XOR |
查找函数
| ADDRESS | AREAS | CHOOSE | COLUMN |
| COLUMNS | FORMULATEXT | HLOOKUP | HYPERLINK |
| INDEX | INDIRECT | LOOKUP | MATCH |
| OFFSET | ROW | ROWS | RTD |
| TRANSPOSE | VLOOKUP |
数学和三角函数
| ABS | ACOS | ACOSH | ACOT |
| ACOTH | AGGREGATE | ARABIC | ASIN |
| ASINH | ATAN | ATAN2 | ATANH |
| BASE | CEILING | CEILING.MATH | CEILING.PRECISE |
| COMBIN | COMBINA | COS | COSH |
| COT | COTH | CSC | CSCH |
| DECIMAL | DEGREES | EVEN | EXP |
| FACT | FACTDOUBLE | FLOOR | FLOOR.MATH |
| FLOOR.PRECISE | GCD | INT | ISO.CEILING |
| LCM | LN | LOG | LOG10 |
| MDETERM | MINVERSE | MMULT | MOD |
| MROUND | MULTINOMIAL | MUNIT | ODD |
| PI | POWER | PRODUCT | QUOTIENT |
| RADIANS | RAND | RANDBETWEEN | ROMAN |
| ROUND | ROUNDDOWN | ROUNDUP | SEC |
| SECH | SERIESSUM | SIGN | SIN |
| SINH | SQRT | SQRTPI | SUBTOTAL |
| SUM | SUMIF | SUMIFS | SUMPRODUCT |
| SUMSQ | SUMX2MY2 | SUMX2PY2 | SUMXMY2 |
| TAN | TANH | TRUNC |
统计函数
| AVEDEV | AVERAGE | AVERAGEA | AVERAGEIF |
| AVERAGEIFS | BETADIST | BETA.DIST | BETAINV |
| BETA.INV | BINOMDIST | BINOM.DIST | BINOM.DIST.RANGE |
| BINOM.INV | CHIDIST | CHIINV | CHISQ.DIST |
| CHISQ.DIST.RT | CHISQ.INV | CHISQ.INV.RT | CHISQ.TEST |
| CHITEST | CONFIDENCE | CONFIDENCE.NORM | CONFIDENCE.T |
| CORREL | COUNT | COUNTIF | COUNTIFS |
| COUNTA | COVAR | COVARIANCE.P | COVARIANCE.S |
| CRITBINOM | DEVSQ | EXPONDIST | EXPON.DIST |
| FDIST | F.DIST | F.DIST.RT | FINV |
| F.INV | F.INV.RT | FISHER | FISHERINV |
| FORECAST | FREQUENCY | FTEST | F.TEST |
| GAMMA | GAMMADIST | GAMMA.DIST | GAMMAINV |
| GAMMA.INV | GAMMALN | GAMMALN.PRECISE | GAUSS |
| GEOMEAN | GROWTH | HARMEAN | HYPGEOMDIST |
| HYPGEOM.DIST | INTERCEPT | KURT | LARGE |
| LINEST | LOGEST | LOGINV | LOGNORMDIST |
| LOGNORM.DIST | LOGNORM.INV | MAX | MAXA |
| MAXIFS | MEDIAN | MIN | MINA |
| MINIFS | MODE | MODE.MULT | MODE.SNGL |
| NEGBINOMDIST | NEGBINOM.DIST | NORMDIST | NORM.DIST |
| NORMINV | NORM.INV | NORMSDIST | NORM.S.DIST |
| NORMSINV | NORM.S.INV | PEARSON | PERCENTILE |
| PERCENTILE.EXC | PERCENTILE.INC | PERCENTRANK | PERCENTRANK.EXC |
| PERCENTRANK.INC | PERMUT | PERMUTATIONA | PHI |
| POISSON | POISSON.DIST | PROB | QUARTILE |
| QUARTILE.EXC | QUARTILE.INC | RANK | RANK.AVG |
| RANK.EQ | RSQ | SKEW | SKEW.P |
| SLOPE | SMALL | STANDARDIZE | STDEV |
| STDEVA | STDEVP | STDEV.P | STDEVPA |
| STDEV.S | STEYX | TDIST | T.DIST |
| T.DIST.2T | T.DIST.RT | TINV | T.INV |
| T.INV.2T | TREND | TRIMMEAN | TTEST |
| T.TEST | VAR | VARA | VARP |
| VAR.P | VARPA | VAR.S | WEIBULL |
| WEIBULL.DIST | ZTEST | Z.TEST |
文本函数
| ASC | BAHTTEXT | CHAR | CLEAN |
| CODE | CONCAT | CONCATENATE | DBCS |
| DOLLAR | EXACT | FIND | FINDB |
| FIXED | JIS | LEFT | LEFTB |
| LEN | LENB | LOWER | MID |
| MIDB | NUMBERVALUE | PROPER | REPLACE |
| REPLACEB | REPT | RIGHT | RIGHTB |
| SEARCH | SEARCHB | SUBSTITUTE | T |
| TEXT | TEXTJOIN | TRIM | UPPER |
| UNICHAR | UNICODE | USDOLLAR | VALUE |
网络函数
| ENCODEURL | FILTERXML | WEBSERVICE |